package com.newbingo.service;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.text.SimpleDateFormat;
import java.util.Date;

import com.newbingo.dao.imple.IBackupDao;
import com.newbingo.entity.Backup;
import com.newbingo.service.imple.IBackupService;
import com.newbingo.util.Pager;

public class BackupService implements IBackupService {

	private IBackupDao backupDao = null;

	/*
	 * 删除(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#delete(com.newbingo.entity.Backup)
	 */
	public void delete(Backup backup) {
		System.out.println("调用了删除的方法");
		backupDao.delete(backup);

	}

	/*
	 * 根据ID查询(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#findById(java.lang.Integer)
	 */
	public Backup findById(Integer Id) {
		return backupDao.findById(Id);
	}

	/*
	 * 分页查询(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#findByPage(int, int)
	 */
	public Pager findByPage(int start, int limit) {
		return backupDao.findByPage(start, limit);
	}

	/*
	 * 保存(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#save(com.newbingo.entity.Backup)
	 */
	public void save(Backup backup) {
		backupDao.save(backup);
	}

	/*
	 * 备份(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#backup(java.lang.String)
	 */
	public boolean backup(String fileName) {
		try {
			Runtime rt = Runtime.getRuntime(); // 调用 mysql 的 cmd:
			Process child = rt
					.exec("D:/Program Files/MySQL/MySQL Server 5.1/bin/mysqldump -uroot -padmin newbingo");// 设置导出编码为utf8。这里必须是utf8

			// 把进程执行中的控制台输出信息写入.sql文件，即生成了备份文件。注：如果不对控制台信息进行读出，则会导致进程堵塞无法运行
			InputStream in = child.getInputStream();// 控制台的输出信息作为输入流
			InputStreamReader xx = new InputStreamReader(in, "utf8");
			// 设置输出流编码为utf8。这里必须是utf8，否则从流中读入的是乱码
			String inStr;
			StringBuffer sb = new StringBuffer("");
			String outStr;
			// 组合控制台输出信息字符串
			BufferedReader br = new BufferedReader(xx);
			while ((inStr = br.readLine()) != null) {
				sb.append(inStr + "\r\n");
			}
			outStr = sb.toString();
			// 要用来做导入用的sql目标文件：
			FileOutputStream fout = new FileOutputStream("d:/" + fileName
					+ ".sql");
			OutputStreamWriter writer = new OutputStreamWriter(fout, "utf8");
			writer.write(outStr); // 注：这里如果用缓冲方式写入文件的话，会导致中文乱码，用flush()方法则可以避免
			writer.flush(); // 别忘记关闭输入输出流
			in.close();
			xx.close();
			br.close();
			writer.close();
			fout.close();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	/*
	 * 还原(non-Javadoc)
	 * 
	 * @see com.newbingo.service.imple.IBackupService#restore(java.lang.String)
	 */
	public boolean restore(String fileName) {
		try {
			String fPath = "d:/" + fileName + ".sql";
			Runtime rt = Runtime.getRuntime();
			// 调用 mysql 的 cmd:
			Process child = rt
					.exec("D:/Program Files/MySQL/MySQL Server 5.1/bin/mysql.exe -uroot -padmin newbingo ");
			OutputStream out = child.getOutputStream();// 控制台的输入信息作为输出流
			String inStr;
			StringBuffer sb = new StringBuffer("");
			String outStr;
			BufferedReader br = new BufferedReader(new InputStreamReader(
					new FileInputStream(fPath), "utf8"));
			while ((inStr = br.readLine()) != null) {
				sb.append(inStr + "\r\n");
			}
			outStr = sb.toString();
			OutputStreamWriter writer = new OutputStreamWriter(out, "utf8");
			writer.write(outStr);
			// 注：这里如果用缓冲方式写入文件的话，会导致中文乱码，用flush()方法则可以避免
			writer.flush(); // 别忘记关闭输入输出流
			out.close();
			br.close();
			writer.close();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	/*
	 * 删除指定入径的文件(non-Javadoc)
	 * @see com.newbingo.service.imple.IBackupService#deleteFile(java.lang.String)
	 */
	public boolean deleteFile(String fileName) {
		try {
			String[] cmdArray = { "cmd", "/c", "del", "D:\\"+fileName+".sql" };
			Runtime.getRuntime().exec(cmdArray);
			return true;
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

	public IBackupDao getBackupDao() {
		return backupDao;
	}

	public void setBackupDao(IBackupDao backupDao) {
		this.backupDao = backupDao;
	}

}
